1. How can I know when a stored procedure finishes execution? coderanch.comHello everyone! I've got an Oracle stored procedure which I am calling from a Java applet. This procedure takes more than 20 mins to finish and returns no results. Is there any way to know when the procedure ends? (Prefferably without having to alter the procedure's code). The procedure does a lot of delete/update/insert queries to several tables. Up until now ... |
2. Pointbase : How can I create a stored procedures with Pointbase database? coderanch.comHello, Excuse me for my english, I'm not anglophone. I try to create a stored procedure. This is my file SampleExternalMethods.java : import java.sql.*; //import com.pointbase.jdbc.jdbcInOutDoubleWrapper; public class SampleExternalMethods { // A connection object to allow database callback static Connection conn = null; static Statement l_stmt; static Statement m_stmt; static CallableStatement m_callStmt = null; static ResultSet l_rs = null; public static ... |
4. Trouble executing stored procedure and getting a value back coderanch.comHi I have a stored procedure in SQL Server 2005. I've set up the user for this, etc., and it should work. The stored procedure takes 4 parameters. Actually 5. The one on the end is the OUTPUT parameter. So, in SQL Server a call to the stored procedure would be like this: EXEC SP_GET_NUMBER '555-55-5555','19451215','DUGGAR','BILLYBOB', @NUMBER OUTPUT The result is ... |
5. StoredProcedure on a DBLink. coderanch.comHi, I am pretty new to JDBC and hibernate, might be stupid so please don't get angry. I need to run a stored procedure on a DB via a DBLink because of direct access restrictions. I came to know about it only after I wrote some code with the expectation it will work. I use spring JDBC to call the stored ... |
6. How to store Output variables of a Stored Procedure in java coderanch.com |
7. Stored Procedures Having Object coderanch.com |
8. Change Increment index of for loop in stored procedure coderanch.comHI All , To my stored procedure of Oracle i am passing a type , which contains some array of integers. To fetch the values i am using for loop. The problem is the increment index is 1 . I want to change it to 2. How is it possible ? Please help me on this. |
9. Framework for simpler stored procedure access? coderanch.comHi, Have you looked at the iBatis ? It may not generate the every part of the code but you can configure the stored procs. in a XML. If you follow some standard writing all the stored procs. for e.g if you define all of your stored procs. would have one input and one output parameter then you can have a ... |
10. looping in stored procedure coderanch.comHi, I have a query like this, select email as vEmail from users where id in (217211,217521,217641) Now this query returns 3 email id's. I have to loop through the vEmail and assign them to different local variables in stored procedures. like email for 217211 is stored in vEmail1 217521 in vEmail2 217641 in vEmail3 Can somehow help me in this ... |
11. getting gateway timeout while executing a stored procedure via jdbc coderanch.com |
12. How to understand which datatype is being output from a stored procedure coderanch.comHello, I am trying to write a function which takes stored procedure's name and it's arguments as argument and execute it. Now I want that, the function should be able to know wat data is being output from the sp, so I can set datatype of output variable of sp. How to do this ? |
13. Need some help in JDBC and stored procedures dbforums.comHi All, i m not so sure if this the right place to write this message but i hope i can get some help from here.So, i have a procedure like this : CREATE OR REPLACE procedure hello is begin htp.htmlOpen; htp.bodyOpen; htp.p('hello world'); htp.bodyClose; htp.htmlClose; end; / and i m trying to execute it using java, which has the part ... |
14. stored procedure java-forums.org |
15. Default values of stored procedures java-forums.org |
16. Executing stored procedures java-forums.orghello: syntax: {call procedure_name[(?, ?, ...)]} The syntax for a procedure that returns a result parameter is: {? = call procedure_name[(?, ?, ...)]} The syntax for a stored procedure with no parameters would look like this: {call procedure_name} CallableStatement cstmt = con.prepareCall( {call getTestData(?, ?)}); cstmt.registerOutParameter(1, java.sql.Types.TINYINT); cstmt.registerOutParameter(2, java.sql.Types.DECIMAL, 3); cstmt.executeQuery(); byte x = cstmt.getByte(1); java.math.BigDecimal n = cstmt.getBigDecimal(2, 3); CallableStatement ... |
17. Stored Procedures with java java-forums.orgI must do an application J2EE to execute stored procedures, that is a hugh problem, because I really know how can I do that, but my question is the following one: There are stored procedures that delay long time in finishing processing, for example 5 minutes (I have one delays 20 hours), time in which my application could fall by timeout. ... |
18. Stored Procedures java-forums.org |
19. unable to exceute stored procedures java-forums.orgimport java.sql.*; public class CrTable { //Add an employee to the database. public static void addEmp(int emp_id, String emp_f_name, String emp_l_name,float emp_salary) { System.out.println("Creating new employee..."); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver"); Connection con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=master;user=sa;passwor d=remora"); System.out.println("connceted----->"+con.getClass()); String sql = "INSERT INTO emp " + "(emp_id,emp_f_name,emp_l_name,emp_salary)" + "VALUES(?,?,?,?)"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setInt(1,emp_id); pstmt.setString(2,emp_f_name); pstmt.setString(3,emp_l_name); pstmt.setFloat(4,emp_salary); pstmt.executeUpdate(); pstmt.close(); } catch(Exception e) { System.err.println("ERROR! Adding Employee: ... |